Charting on an OLAP cube (OLAP layout)

The OLAP layout lets you chart on an OLAP grid. In order to create an OLAP chart, you must first have an OLAP grid in your report. For more information, see Creating an OLAP report.

To chart on an OLAP cube

1. On the Insert menu, click Chart.

   The Chart Expert dialog box appears.

2. On the Type tab, in the Chart type list, click the chart type that best illustrates your data. See Chart types.
3. Click the Data tab.

   

4. In the Layout area, click OLAP.
5. In the Placement area, click Header or Footer to specify where to place your chart.

   Note:    How often your chart appears on the report depends on where the OLAP grid has been placed.

6. In the Data area, in the On change of list, click the field you want to base your chart on.
7. If necessary, in the Subdivided by list, click a secondary row or column you want to base your chart on.
8. On the Axes and Options tab, add data values, a legend, or other elements to your chart.
9. Click the Text tab.
10. Accept the default title information or add new titles your chart.
11. Click OK.

    Your chart is placed in the Header or Footer section of the report, depending on your selection in Step 5.